I just want to retrieve data from my emp_mstr table and display it using my JSP file...
The table emp_mstr is as follows :-
Expand|Select|Wrap|Line Numbers
- CREATE TABLE EMP_MSTR(
- EMP_NO VARCHAR(10) PRIMARY KEY,
- PASSWORD VARCHAR(6),
- BRANCH_NO VARCHAR(10),
- FNAME VARCHAR(25),
- MNAME VARCHAR(25),
- LNAME VARCHAR(25),
- DEPT VARCHAR(30),
- DESIG VARCHAR(30),
- ADDR VARCHAR(50)
- );
My JSP file is as follows :-
Expand|Select|Wrap|Line Numbers
- <html>
- <head>
- <meta http-equiv="content-type" content="text/html; charset=utf-8" />
- <title>corporate bank</title>
- <meta name="keywords" content="" />
- <meta name="description" content="" />
- <link href="../resource/styles.css" rel="stylesheet" type="text/css" media="screen" />
- </head>
- <body>
- <div id="main">
- <!-- start header -->
- <div id="header">
- <div id="logo">
- <h1>Corporate Bank</h1>
- </div>
- <!--Header end -->
- <div id="menu">
- <ul>
- <li><a href="#">Home</a></li>
- <li><a href="#">Products</a></li>
- <li><a href="#">Easy loans</a></li>
- <li><a href="#">About us</a></li>
- <li><a href="#">Contact</a></li>
- </ul>
- </div>
- </div>
- <!-- end header -->
- <!-- start page -->
- <div id="page">
- <!-- start leftbar -->
- <div id="leftbar" class="sidebar">
- <h2>Branch Network</h2>
- <div class="back">
- <ul>
- <li><a href="#">Branches</a></li>
- <li><a href="#">ATMs</a></li>
- <li><a href="#">Overseas Branches</a></li>
- <li><a href="#">Phone banking numbers</a></li>
- </ul>
- </div><div class="bottom"></div>
- <h2>General Information</h2>
- <div class="back">
- <ul>
- <li><a href="#">Interest rates on FD</a></li>
- <li><a href="#">Service charges and fees</a></li>
- <li><a href="#">Download Forms</a></li>
- <li><a href="#">FAQ's</a></li>
- </ul>
- </div>
- <div class="bottom"></div>
- </div>
- <!-- end leftbar -->
- <!-- start content -->
- <div id="content">
- <div class="post">
- <h1 class="title">Employee Details</h1>
- <br><br> <center><table>
- <tr>
- <td>
- <div>Employee No.</div>
- </td>
- <td><bean:write name="employeeDetailForm" property="empNo"/></td>
- </tr><tr></tr><tr></tr><tr></tr>
- <tr valign="top">
- <td>
- <div>Branch No.</div>
- </td>
- <td><bean:write name="employeeDetailForm" property="branchNo"/></td>
- </tr><tr></tr><tr></tr><tr></tr>
- <tr valign="top">
- <td>
- <div>First Name</div>
- </td>
- <td><bean:write name="employeeDetailForm" property="fName"/></td>
- </tr><tr></tr><tr></tr><tr></tr>
- <tr valign="top">
- <td>
- <div>Middle Name</div>
- </td>
- <td><bean:write name="employeeDetailForm" property="mName"/></td>
- </tr><tr></tr><tr></tr><tr></tr>
- <tr valign="top">
- <td>
- <div>Last Name</div>
- </td>
- <td><bean:write name="employeeDetailForm" property="lName"/></td>
- </tr><tr></tr><tr></tr><tr></tr>
- <tr valign="top">
- <td>
- <div>Department</div>
- </td>
- <td><bean:write name="employeeDetailForm" property="dept"/></td>
- </tr><tr></tr><tr></tr><tr></tr>
- <tr valign="top">
- <td>
- <div>Designation</div>
- </td>
- <td><bean:write name="employeeDetailForm" property="desig"/></td>
- </tr><tr></tr><tr></tr><tr></tr>
- <tr valign="top">
- <td>
- <div>Address</div>
- </td>
- <td><bean:write name="employeeDetailForm" property="address"/></td>
- </tr><tr></tr><tr></tr><tr></tr>
- <tr valign="top">
- <td>
- </tr><tr></tr><tr></tr><tr></tr><tr></tr><tr></tr><tr></tr>
- <tr></tr><tr></tr><tr></tr><tr></tr>
- <tr><td colspan=2>
- <center><a href="search employee.html">Search Employee</a></center>
- </td>
- </tr>
- <tr></tr><tr></tr><tr></tr><tr></tr>
- <tr><td colspan=2>
- <center><a href="search customer.html">Search Customer</a></center>
- </td>
- </tr>
- <tr></tr><tr></tr><tr></tr><tr></tr>
- <tr><td colspan=2>
- <center><a href="activate saving account.html">Activate Account</a></center>
- </td>
- </tr>
- <tr></tr><tr></tr><tr></tr><tr></tr>
- <tr><td colspan=2>
- <center><a href="new employee.html">New Employee</a></center>
- </td>
- </tr>
- </table></center>
- <br><br>
- </div>
- </div>
- <!-- end content -->
- <!-- start rightbar -->
- <div id="rightbar" class="sidebar">
- <h2>Login</h2>
- <div class="back">
- <form action="">
- <center><table>
- <tr ><td color=#000000>You have logged in as:</td></tr>
- <tr><td><center>.......</center></td>
- </tr>
- <tr></tr><tr></tr><tr></tr><tr></tr><tr></tr><tr></tr><tr></tr><tr></tr><tr></tr>
- <tr></tr><tr></tr><tr></tr><tr></tr>
- <tr><td><center><a href="#">logout<a><center></td></tr>
- <tr></tr><tr></tr> </table></center>
- </form>
- </div><div class="bottom"></div>
- <h2>News</h2>
- <div class="back">
- <ul>
- <li><a href="#">Aliquam libero</a></li>
- <li><a href="#">Consectetuer adipiscing elit</a></li>
- <li><a href="#">Urnanet non molestie semper</a></li>
- <li><a href="#">Proin gravida orci porttitor</a></li>
- </ul>
- </div><div class="bottom"></div>
- </div>
- <!-- end rightbar -->
- <div style="clear: both;"> </div>
- </div>
- <!-- end page -->
- <div id="footer">
- <p>Copyright © 2009. <a href="#">Privacy Policy</a> | <a href="#">Terms of Use</a> | <a href="#" title="This page validates as XHTML 1.0 Transitional"><abbr title="eXtensible HyperText Markup Language">XHTML</abbr></a> | <a href="#" title="This page validates as CSS"><abbr title="Cascading Style Sheets">CSS</abbr></a></p>
- <p>Design by <a href="#" title="CORPORATE BANK">Corporate Bank</a></p>
- </div>
- </html>
Expand|Select|Wrap|Line Numbers
- package com.kmg.employee;
- import org.apache.struts.action.ActionForm;
- public class employeeDetailForm extends ActionForm{
- private String empNo;
- private String password;
- private String fName;
- private String mName;
- private String lName;
- private String dept;
- private String desig;
- private String address;
- public String getempNo() {
- return empNo;
- }
- public void setempNo(String empNo) {
- this.empNo = empNo;
- }
- public String getpassword() {
- return password;
- }
- public void setpassword(String password) {
- this.password = password;
- }
- public String getfName() {
- return fName;
- }
- public void setfName(String name) {
- fName = name;
- }
- public String getmName() {
- return mName;
- }
- public void setmName(String name) {
- mName = name;
- }
- public String getlName() {
- return lName;
- }
- public void setlName(String name) {
- lName = name;
- }
- public String getDept() {
- return dept;
- }
- public void setDept(String dept) {
- this.dept = dept;
- }
- public String getDesig() {
- return desig;
- }
- public void setDesig(String desig) {
- this.desig = desig;
- }
- public String getAddress() {
- return address;
- }
- public void setAddress(String address) {
- this.address = address;
- }
- }
Expand|Select|Wrap|Line Numbers
- package com.kmg.employee;
- import com.kmg.employee.employeeDetailForm;
- import com.kmg.services.*;
- import java.sql.Connection;
- import javax.servlet.http.*;
- import javax.sql.DataSource;
- import org.apache.struts.action.*;
- public class employeeDetailAction extends Action {
- public ActionForward execute(ActionMapping mapping, ActionForm form,
- HttpServletRequest request, HttpServletResponse response)
- throws Exception {
- employeeDetailForm employeeDetailForm = (employeeDetailForm) form;
- EmployeeDAO employeeDAO = new EmployeeDAO();
- Employee employee = new Employee();
- Connection con = null;
- DataSource ds = null;
- ds = getDataSource(request);
- employee.setempNo(employeeDetailForm.getempNo());
- String password = employeeDetailForm.getpassword();
- String fName = employeeDetailForm.getfName();
- String mName = employeeDetailForm.getmName();
- String lName = employeeDetailForm.getlName();
- String dept = employeeDetailForm.getDept();
- String desig = employeeDetailForm.getDesig();
- String address = employeeDetailForm.getAddress();
- con = employeeDAO.getConnection(ds);
- employee = employeeDAO.getRecord(con, employee);
- employeeDAO.closeConnection(con);
- return mapping.getInputForward();
- }
- }
Expand|Select|Wrap|Line Numbers
- package com.kmg.services;
- import java.sql.Connection;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import javax.sql.DataSource;
- public class EmployeeDAO {
- public Connection getConnection(DataSource datasource) {
- Connection con = null;
- DataSource ds = datasource;
- try {
- con = ds.getConnection();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return con;
- }
- public void closeConnection(Connection con) {
- try {
- con.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- public static Employee getRecord(Connection con, Employee employee) {
- String qry = "select PASSWORD from EMP_MSTR where EMP_NO=?";
- String password = null;
- ResultSet resultSet = null;
- try {
- PreparedStatement pstat = con.prepareStatement(qry);
- pstat.setString(1, employee.getempNo());
- resultSet = pstat.executeQuery();
- while (resultSet.next()) {
- employee.setpassword(resultSet.getString("PASSWORD"));
- employee.setfName(resultSet.getString("FNAME"));
- employee.setmName(resultSet.getString("MNAME"));
- employee.setlName(resultSet.getString("LNAME"));
- employee.setDept(resultSet.getString("DEPT"));
- employee.setDesig(resultSet.getString("DESIG"));
- employee.setAddress(resultSet.getString("ADDR"));
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return employee;
- }
- }
Expand|Select|Wrap|Line Numbers
- package com.kmg.services;
- public class Employee {
- private String empNo;
- private String password;
- private String fName;
- private String mName;
- private String lName;
- private String dept;
- private String desig;
- private String address;
- public String getempNo() {
- return empNo;
- }
- public void setempNo(String empNo) {
- this.empNo = empNo;
- }
- public String getpassword() {
- return password;
- }
- public void setpassword(String password) {
- this.password = password;
- }
- public String getfName() {
- return fName;
- }
- public void setfName(String name) {
- fName = name;
- }
- public String getmName() {
- return mName;
- }
- public void setmName(String name) {
- mName = name;
- }
- public String getlName() {
- return lName;
- }
- public void setlName(String name) {
- lName = name;
- }
- public String getDept() {
- return dept;
- }
- public void setDept(String dept) {
- this.dept = dept;
- }
- public String getDesig() {
- return desig;
- }
- public void setDesig(String desig) {
- this.desig = desig;
- }
- public String getAddress() {
- return address;
- }
- public void setAddress(String address) {
- this.address = address;
- }
- }
Expand|Select|Wrap|Line Numbers
- <?xml version="1.0" encoding="UTF-8"?>
- <!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.2//EN" "http://struts.apache.org/dtds/struts-config_1_2.dtd">
- <struts-config>
- <data-sources>
- <data-source type="org.apache.commons.dbcp.BasicDataSource">
- <set-property
- property="driverClassName"
- value="com.mysql.jdbc.Driver" />
- <set-property
- property="url"
- value="jdbc:mysql://localhost:3306/bank_sys?autoReconnect=true" />
- <set-property
- property="username"
- value="root"/>
- <set-property
- property="password"
- value="hr"/>
- </data-source>
- </data-sources>
- <form-beans>
- <form-bean name="index1Form"
- type="com.kmg.customer.Index1Form"/>
- <form-bean name="index2Form"
- type="com.kmg.employee.Index2Form"/>
- <form-bean name="employeeDetailForm"
- type="com.kmg.employee.employeeDetailForm"/>
- </form-beans>
- <!-- Action Mappings Configuration -->
- <action-mappings>
- <action path="/index1"
- type="com.kmg.customer.Index1Action"
- name="index1Form"
- input="/jsp/index1.jsp">
- <forward name="accountDetail" path="/jsp/accountDetail.jsp"/>
- </action>
- <action path="/index2"
- type="com.kmg.employee.Index2Action"
- name="index2Form"
- input="/jsp/index2.jsp">
- <forward name="employeeDetail" path="/jsp/employeeDetail.jsp"/>
- </action>
- <action path="/employeeDetail"
- type="com.kmg.employee.employeeDetailAction"
- name="employeeDetailForm"
- input="/jsp/employeeDetail.jsp">
- </action>
- </action-mappings>
- </struts-config>
web.xml
Expand|Select|Wrap|Line Numbers
- <?xml version="1.0" encoding="UTF-8"?>
- <web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.4" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
- <servlet>
- <servlet-name>action</servlet-name>
- <servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
- <init-param>
- <param-name>config</param-name>
- <param-value>/WEB-INF/struts-config.xml</param-value>
- </init-param>
- <init-param>
- <param-name>debug</param-name>
- <param-value>3</param-value>
- </init-param>
- <init-param>
- <param-name>detail</param-name>
- <param-value>3</param-value>
- </init-param>
- <load-on-startup>0</load-on-startup>
- </servlet>
- <servlet-mapping>
- <servlet-name>action</servlet-name>
- <url-pattern>*.do</url-pattern>
- </servlet-mapping>
- <welcome-file-list>
- <welcome-file>/jsp/employeeDetail.jsp</welcome-file>
- </welcome-file-list>
- </web-app>
But I really need help. I m SOO lost. How to display data retrieved from database using JSP file ?? Nothing is getting displayed when I run the JSP file.